﻿-- =============================================
-- Script Template
-- =============================================

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [Sys_RoleActivity]'
GO

-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
-- Data for System Super Admin                                                                                                                                                                                                                                                                                                                                   Data for System Super Admin                            
-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
PRINT '.............. [Allocating Activities for System Super Admin]'
GO
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 2, N'SYSSPRADM', N'System Super Admin', N'CREATE_MYPROFILE', N'Create MYPROFILE Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 3, N'SYSSPRADM', N'System Super Admin', N'READ_MYPROFILE', N'Read MYPROFILE Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 157, N'SYSSPRADM', N'System Super Admin', N'UPDATE_MYPROFILE', N'Update MYPROFILE Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 4, N'SYSSPRADM', N'System Super Admin', N'DELETE_MYPROFILE', N'Delete MYPROFILE Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 8, N'SYSSPRADM', N'System Super Admin', N'VIEW_SYSADMINDASHBOARD', N'View System Administration Dashboard', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 9, N'SYSSPRADM', N'System Super Admin', N'CREATE_ACTIVITYMASTER', N'Create new ACTIVITYMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 10, N'SYSSPRADM', N'System Super Admin', N'READ_ACTIVITYMASTER', N'Read ACTIVITYMASTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 11, N'SYSSPRADM', N'System Super Admin', N'UPDATE_ACTIVITYMASTER', N'Update ACTIVITYMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 12, N'SYSSPRADM', N'System Super Admin', N'DELETE_ACTIVITYMASTER', N'Delete ACTIVITYMASTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 13, N'SYSSPRADM', N'System Super Admin', N'CREATE_ROLEMASTER', N'Create new ROLEMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 14, N'SYSSPRADM', N'System Super Admin', N'READ_ROLEMASTER', N'Read ROLEMASTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 15, N'SYSSPRADM', N'System Super Admin', N'UPDATE_ROLEMASTER', N'Update ROLEMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 16, N'SYSSPRADM', N'System Super Admin', N'DELETE_ROLEMASTER', N'Delete ROLEMASTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 17, N'SYSSPRADM', N'System Super Admin', N'CREATE_ROLEACTIVITY', N'Create new ROLEACTIVITY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 18, N'SYSSPRADM', N'System Super Admin', N'READ_ROLEACTIVITY', N'Read ROLEACTIVITY Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 19, N'SYSSPRADM', N'System Super Admin', N'UPDATE_ROLEACTIVITY', N'Update ROLEACTIVITY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 20, N'SYSSPRADM', N'System Super Admin', N'DELETE_ROLEACTIVITY', N'Delete ROLEACTIVITY Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 21, N'SYSSPRADM', N'System Super Admin', N'CREATE_ROLEALLOCATION', N'Create new ROLEALLOCATION Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 22, N'SYSSPRADM', N'System Super Admin', N'READ_ROLEALLOCATION', N'Read ROLEALLOCATION Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 23, N'SYSSPRADM', N'System Super Admin', N'UPDATE_ROLEALLOCATION', N'Update ROLEALLOCATION Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 24, N'SYSSPRADM', N'System Super Admin', N'DELETE_ROLEALLOCATION', N'Delete ROLEALLOCATION Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--Start INSERT RoleActivity Code for ROLEALLOCATION (Created by "Ram pravesh kr")
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 25, N'SYSSPRADM', N'System Super Admin', N'SEE_ROLEALLOCATION', N'See ROLEALLOCATION Data only self created data from DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 26, N'SYSSPRADM', N'System Super Admin', N'EDIT_ROLEALLOCATION', N'Edit ROLEALLOCATION Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 27, N'SYSSPRADM', N'System Super Admin', N'REMOVE_ROLEALLOCATION', N'Remove ROLEALLOCATION Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 28, N'SYSSPRADM', N'System Super Admin', N'INSERT_ROLEALLOCATION', N'Insert ROLEALLOCATION Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 29, N'SYSSPRADM', N'System Super Admin', N'GET_ROLEALLOCATION', N'Get/Read ROLEALLOCATION Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 30, N'SYSSPRADM', N'System Super Admin', N'CHANGE_ROLEALLOCATION', N'Change ROLEALLOCATION Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 31, N'SYSSPRADM', N'System Super Admin', N'ERASE_ROLEALLOCATION', N'Erase/Purge ROLEALLOCATION Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--End INSERT RoleActivity Code for ROLEALLOCATION (Created by "Ram pravesh kr")
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 32, N'SYSSPRADM', N'System Super Admin', N'READ_SESSIONLOG', N'Read SESSIONLOG Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 33, N'SYSSPRADM', N'System Super Admin', N'DELETE_SESSIONLOG', N'Delete SESSIONLOG Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 34, N'SYSSPRADM', N'System Super Admin', N'READ_ERRORLOG', N'Read ERRORLOG Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 35, N'SYSSPRADM', N'System Super Admin', N'DELETE_ERRORLOG', N'Delete ERRORLOG Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 36, N'SYSSPRADM', N'System Super Admin', N'READ_SIGNUP', N'Read SIGNUP Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 37, N'SYSSPRADM', N'System Super Admin', N'UPDATE_SIGNUP', N'Update SIGNUP Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 38, N'SYSSPRADM', N'System Super Admin', N'DELETE_SIGNUP', N'Delete SIGNUP Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 40, N'SYSSPRADM', N'System Super Admin', N'READ_GENERALFEEDBACK', N'Read GENERALFEEDBACK Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 41, N'SYSSPRADM', N'System Super Admin', N'DELETE_GENERALFEEDBACK', N'Delete GENERALFEEDBACK Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 45, N'SYSSPRADM', N'System Super Admin', N'READ_CONTACTUS', N'Read CONTACTUS Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 46, N'SYSSPRADM', N'System Super Admin', N'DELETE_CONTACTUS', N'Delete CONTACTUS Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 50, N'SYSSPRADM', N'System Super Admin', N'READ_SUBSCRIPTION', N'Read SUBSCRIPTION Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 51, N'SYSSPRADM', N'System Super Admin', N'CREATE_CONTENTTYPEMASTER', N'Create new CONTENTTYPEMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 53, N'SYSSPRADM', N'System Super Admin', N'UPDATE_CONTENTTYPEMASTER', N'Update CONTENTTYPEMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 54, N'SYSSPRADM', N'System Super Admin', N'DELETE_CONTENTTYPEMASTER', N'Delete CONTENTTYPEMASTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 59, N'SYSSPRADM', N'System Super Admin', N'UPDATE_PUBLICCONTENT', N'Update PUBLICCONTENT Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 60, N'SYSSPRADM', N'System Super Admin', N'DELETE_PUBLICCONTENT', N'Delete PUBLICCONTENT Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 65, N'SYSSPRADM', N'System Super Admin', N'DELETE_PUBLICCONTENTFEEDBACK', N'Delete PUBLICCONTENTFEEDBACK Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 68, N'SYSSPRADM', N'System Super Admin', N'CREATE_GROUPCONTENT', N'Create new GROUPCONTENT Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 69, N'SYSSPRADM', N'System Super Admin', N'READ_GROUPCONTENT', N'Read GROUPCONTENT Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 70, N'SYSSPRADM', N'System Super Admin', N'UPDATE_GROUPCONTENT', N'Update GROUPCONTENT Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 71, N'SYSSPRADM', N'System Super Admin', N'DELETE_GROUPCONTENT', N'Delete GROUPCONTENT Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 79, N'SYSSPRADM', N'System Super Admin', N'READ_GROUPCONTENTFEEDBACK', N'Read GROUPCONTENTFEEDBACK Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 80, N'SYSSPRADM', N'System Super Admin', N'DELETE_GROUPCONTENTFEEDBACK', N'Delete GROUPCONTENTFEEDBACK Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 89, N'SYSSPRADM', N'System Super Admin', N'UPDATE_PROJECTMEMBER', N'Update PROJECTMEMBER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 90, N'SYSSPRADM', N'System Super Admin', N'DELETE_PROJECTMEMBER', N'Delete PROJECTMEMBER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 93, N'SYSSPRADM', N'System Super Admin', N'CREATE_SOCIETY', N'Create new SOCIETY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 95, N'SYSSPRADM', N'System Super Admin', N'UPDATE_SOCIETY', N'Update SOCIETY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 96, N'SYSSPRADM', N'System Super Admin', N'DELETE_SOCIETY', N'Delete SOCIETY Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 101, N'SYSSPRADM', N'System Super Admin', N'CREATE_SOCIETY_SERVICECATELOG', N'Create new SOCIETY_SERVICECATELOG Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 102, N'SYSSPRADM', N'System Super Admin', N'READ_SOCIETY_SERVICECATELOG', N'Read SOCIETY_SERVICECATELOG Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 103, N'SYSSPRADM', N'System Super Admin', N'DELETE_SOCIETY_SERVICECATELOG', N'Delete SOCIETY_SERVICECATELOG Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 111, N'SYSSPRADM', N'System Super Admin', N'CREATE_SOCIETY_COMMASSETFACILITY', N'Create new SOCIETY_COMMASSETFACILITY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 112, N'SYSSPRADM', N'System Super Admin', N'READ_SOCIETY_COMMASSETFACILITY', N'Read SOCIETY_COMMASSETFACILITY Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 113, N'SYSSPRADM', N'System Super Admin', N'DELETE_SOCIETY_COMMASSETFACILITY', N'Delete SOCIETY_COMMASSETFACILITY Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 121, N'SYSSPRADM', N'System Super Admin', N'CREATE_SOCIETY_FLAT', N'Create new SOCIETY_FLAT Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 122, N'SYSSPRADM', N'System Super Admin', N'READ_SOCIETY_FLAT', N'Read SOCIETY_FLAT Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 123, N'SYSSPRADM', N'System Super Admin', N'DELETE_SOCIETY_FLAT', N'Delete SOCIETY_FLAT Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 131, N'SYSSPRADM', N'System Super Admin', N'CREATE_SOCIETY_OWNERREGISTER', N'Create new SOCIETY_OWNERREGISTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 132, N'SYSSPRADM', N'System Super Admin', N'READ_SOCIETY_OWNERREGISTER', N'Read SOCIETY_OWNERREGISTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 133, N'SYSSPRADM', N'System Super Admin', N'DELETE_SOCIETY_OWNERREGISTER', N'Delete SOCIETY_OWNERREGISTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 141, N'SYSSPRADM', N'System Super Admin', N'CREATE_SOCIETY_RESIDENTREGISTER', N'Create new SOCIETY_RESIDENTREGISTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 143, N'SYSSPRADM', N'System Super Admin', N'DELETE_SOCIETY_RESIDENTREGISTER', N'Delete SOCIETY_RESIDENTREGISTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 151, N'SYSSPRADM', N'System Super Admin', N'CREATE_SERVICEMASTER', N'Create new SERVICEMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 153, N'SYSSPRADM', N'System Super Admin', N'UPDATE_SERVICEMASTER', N'Update SERVICEMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 154, N'SYSSPRADM', N'System Super Admin', N'DELETE_SERVICEMASTER', N'Delete SERVICEMASTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
-- Data for System Admin                                                                                                                                                                                                                                                                                                                                   Data for System Admin                            
-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
PRINT '.............. [Allocating Activities for System Admin]'
GO
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 2, N'SYSADMIN', N'System Admin', N'CREATE_MYPROFILE', N'Create MYPROFILE Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 3, N'SYSADMIN', N'System Admin', N'READ_MYPROFILE', N'Read MYPROFILE Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 4, N'SYSADMIN', N'System Admin', N'DELETE_MYPROFILE', N'Delete MYPROFILE Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 8, N'SYSADMIN', N'System Admin', N'VIEW_SYSADMINDASHBOARD', N'View System Administration Dashboard', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 9, N'SYSADMIN', N'System Admin', N'CREATE_ACTIVITYMASTER', N'Create new ACTIVITYMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 10, N'SYSADMIN', N'System Admin', N'READ_ACTIVITYMASTER', N'Read ACTIVITYMASTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 11, N'SYSADMIN', N'System Admin', N'UPDATE_ACTIVITYMASTER', N'Update ACTIVITYMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 13, N'SYSADMIN', N'System Admin', N'CREATE_ROLEMASTER', N'Create new ROLEMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 14, N'SYSADMIN', N'System Admin', N'READ_ROLEMASTER', N'Read ROLEMASTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 15, N'SYSADMIN', N'System Admin', N'UPDATE_ROLEMASTER', N'Update ROLEMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 17, N'SYSADMIN', N'System Admin', N'CREATE_ROLEACTIVITY', N'Create new ROLEACTIVITY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 18, N'SYSADMIN', N'System Admin', N'READ_ROLEACTIVITY', N'Read ROLEACTIVITY Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 19, N'SYSADMIN', N'System Admin', N'UPDATE_ROLEACTIVITY', N'Update ROLEACTIVITY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 21, N'SYSADMIN', N'System Admin', N'CREATE_ROLEALLOCATION', N'Create new ROLEALLOCATION Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 22, N'SYSADMIN', N'System Admin', N'READ_ROLEALLOCATION', N'Read ROLEALLOCATION Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 23, N'SYSADMIN', N'System Admin', N'UPDATE_ROLEALLOCATION', N'Update ROLEALLOCATION Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 32, N'SYSADMIN', N'System Admin', N'READ_SESSIONLOG', N'Read SESSIONLOG Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 34, N'SYSADMIN', N'System Admin', N'READ_ERRORLOG', N'Read ERRORLOG Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 36, N'SYSADMIN', N'System Admin', N'READ_SIGNUP', N'Read SIGNUP Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 37, N'SYSADMIN', N'System Admin', N'UPDATE_SIGNUP', N'Update SIGNUP Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 39, N'SYSADMIN', N'System Admin', N'CREATE_GENERALFEEDBACK', N'Create new GENERALFEEDBACK Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 40, N'SYSADMIN', N'System Admin', N'READ_GENERALFEEDBACK', N'Read GENERALFEEDBACK Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 45, N'SYSADMIN', N'System Admin', N'READ_CONTACTUS', N'Read CONTACTUS Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 50, N'SYSADMIN', N'System Admin', N'READ_SUBSCRIPTION', N'Read SUBSCRIPTION Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 51, N'SYSADMIN', N'System Admin', N'CREATE_CONTENTTYPEMASTER', N'Create new CONTENTTYPEMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 53, N'SYSADMIN', N'System Admin', N'UPDATE_CONTENTTYPEMASTER', N'Update CONTENTTYPEMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 64, N'SYSADMIN', N'System Admin', N'READ_PUBLICCONTENTFEEDBACK', N'Read PUBLICCONTENTFEEDBACK Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 68, N'SYSADMIN', N'System Admin', N'CREATE_GROUPCONTENT', N'Create new GROUPCONTENT Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 69, N'SYSADMIN', N'System Admin', N'READ_GROUPCONTENT', N'Read GROUPCONTENT Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 70, N'SYSADMIN', N'System Admin', N'UPDATE_GROUPCONTENT', N'Update GROUPCONTENT Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 79, N'SYSADMIN', N'System Admin', N'READ_GROUPCONTENTFEEDBACK', N'Read GROUPCONTENTFEEDBACK Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 89, N'SYSADMIN', N'System Admin', N'UPDATE_PROJECTMEMBER', N'Update PROJECTMEMBER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 90, N'SYSADMIN', N'System Admin', N'DELETE_PROJECTMEMBER', N'Delete PROJECTMEMBER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 93, N'SYSADMIN', N'System Admin', N'CREATE_SOCIETY', N'Create new SOCIETY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 95, N'SYSADMIN', N'System Admin', N'UPDATE_SOCIETY', N'Update SOCIETY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 101, N'SYSADMIN', N'System Admin', N'CREATE_SOCIETY_SERVICECATELOG', N'Create new SOCIETY_SERVICECATELOG Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 102, N'SYSADMIN', N'System Admin', N'READ_SOCIETY_SERVICECATELOG', N'Read SOCIETY_SERVICECATELOG Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 111, N'SYSADMIN', N'System Admin', N'CREATE_SOCIETY_COMMASSETFACILITY', N'Create new SOCIETY_COMMASSETFACILITY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 112, N'SYSADMIN', N'System Admin', N'READ_SOCIETY_COMMASSETFACILITY', N'Read SOCIETY_COMMASSETFACILITY Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 121, N'SYSADMIN', N'System Admin', N'CREATE_SOCIETY_FLAT', N'Create new SOCIETY_FLAT Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 122, N'SYSADMIN', N'System Admin', N'READ_SOCIETY_FLAT', N'Read SOCIETY_FLAT Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 131, N'SYSADMIN', N'System Admin', N'CREATE_SOCIETY_OWNERREGISTER', N'Create new SOCIETY_OWNERREGISTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 132, N'SYSADMIN', N'System Admin', N'READ_SOCIETY_OWNERREGISTER', N'Read SOCIETY_OWNERREGISTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 141, N'SYSADMIN', N'System Admin', N'CREATE_SOCIETY_RESIDENTREGISTER', N'Create new SOCIETY_RESIDENTREGISTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 142, N'SYSADMIN', N'System Admin', N'READ_SOCIETY_RESIDENTREGISTER', N'Read SOCIETY_RESIDENTREGISTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 151, N'SYSADMIN', N'System Admin', N'CREATE_SERVICEMASTER', N'Create new SERVICEMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 153, N'SYSADMIN', N'System Admin', N'UPDATE_SERVICEMASTER', N'Update SERVICEMASTER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
-- Data for System Operator                                                                                                                                                                                                                                                                                                                                   Data for System Operator                            
-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
PRINT '.............. [Allocating Activities for System Operator]'
GO
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 3, N'SYSOPRAT', N'System Operator', N'READ_MYPROFILE', N'Read MYPROFILE Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 8, N'SYSOPRAT', N'System Operator', N'VIEW_SYSADMINDASHBOARD', N'View System Administration Dashboard', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 22, N'SYSOPRAT', N'System Operator', N'READ_ROLEALLOCATION', N'Read ROLEALLOCATION Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 40, N'SYSOPRAT', N'System Operator', N'READ_GENERALFEEDBACK', N'Read GENERALFEEDBACK Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 41, N'SYSOPRAT', N'System Operator', N'DELETE_GENERALFEEDBACK', N'Delete GENERALFEEDBACK Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 45, N'SYSOPRAT', N'System Operator', N'READ_CONTACTUS', N'Read CONTACTUS Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 46, N'SYSOPRAT', N'System Operator', N'DELETE_CONTACTUS', N'Delete CONTACTUS Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 50, N'SYSOPRAT', N'System Operator', N'READ_SUBSCRIPTION', N'Read SUBSCRIPTION Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 59, N'SYSOPRAT', N'System Operator', N'UPDATE_PUBLICCONTENT', N'Update PUBLICCONTENT Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 60, N'SYSOPRAT', N'System Operator', N'DELETE_PUBLICCONTENT', N'Delete PUBLICCONTENT Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 65, N'SYSOPRAT', N'System Operator', N'DELETE_PUBLICCONTENTFEEDBACK', N'Delete PUBLICCONTENTFEEDBACK Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 68, N'SYSOPRAT', N'System Operator', N'CREATE_GROUPCONTENT', N'Create new GROUPCONTENT Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 69, N'SYSOPRAT', N'System Operator', N'READ_GROUPCONTENT', N'Read GROUPCONTENT Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 79, N'SYSOPRAT', N'System Operator', N'READ_GROUPCONTENTFEEDBACK', N'Read GROUPCONTENTFEEDBACK Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 89, N'SYSOPRAT', N'System Operator', N'UPDATE_PROJECTMEMBER', N'Update PROJECTMEMBER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 93, N'SYSOPRAT', N'System Operator', N'CREATE_SOCIETY', N'Create new SOCIETY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 102, N'SYSOPRAT', N'System Operator', N'READ_SOCIETY_SERVICECATELOG', N'Read SOCIETY_SERVICECATELOG Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 112, N'SYSOPRAT', N'System Operator', N'READ_SOCIETY_COMMASSETFACILITY', N'Read SOCIETY_COMMASSETFACILITY Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 122, N'SYSOPRAT', N'System Operator', N'READ_SOCIETY_FLAT', N'Read SOCIETY_FLAT Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 132, N'SYSOPRAT', N'System Operator', N'READ_SOCIETY_OWNERREGISTER', N'Read SOCIETY_OWNERREGISTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 142, N'SYSOPRAT', N'System Operator', N'READ_SOCIETY_RESIDENTREGISTER', N'Read SOCIETY_RESIDENTREGISTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
-- Data for System Registered User                                                                                                                                                                                                                                                                                                                                   Data for System Registered User                            
-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
PRINT '.............. [Allocating Activities for System Registered User]'
GO
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 1, N'SYSREGUSR', N'System Registered User', N'VIEW_MYDASHBOARD', N'View My Dashboard', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 5, N'SYSREGUSR', N'System Registered User', N'SEE_MYPROFILE', N'See MYPROFILE Data only self created data from DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 6, N'SYSREGUSR', N'System Registered User', N'EDIT_MYPROFILE', N'Edit MYPROFILE Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 7, N'SYSREGUSR', N'System Registered User', N'REMOVE_MYPROFILE', N'Remove MYPROFILE Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 25, N'SYSREGUSR', N'System Registered User', N'SEE_ROLEALLOCATION', N'See ROLEALLOCATION Data only self created data from DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 26, N'SYSREGUSR', N'System Registered User', N'EDIT_ROLEALLOCATION', N'Edit ROLEALLOCATION Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 27, N'SYSREGUSR', N'System Registered User', N'REMOVE_ROLEALLOCATION', N'Remove ROLEALLOCATION Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 52, N'SYSREGUSR', N'System Registered User', N'READ_CONTENTTYPEMASTER', N'Read CONTENTTYPEMASTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 55, N'SYSREGUSR', N'System Registered User', N'EDIT_CONTENTTYPEMASTER', N'Edit CONTENTTYPEMASTER Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 56, N'SYSREGUSR', N'System Registered User', N'REMOVE_CONTENTTYPEMASTER', N'Remove CONTENTTYPEMASTER Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 57, N'SYSREGUSR', N'System Registered User', N'CREATE_PUBLICCONTENT', N'Create new PUBLICCONTENT Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 61, N'SYSREGUSR', N'System Registered User', N'EDIT_PUBLICCONTENT', N'Edit PUBLICCONTENT Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 62, N'SYSREGUSR', N'System Registered User', N'REMOVE_PUBLICCONTENT', N'Remove PUBLICCONTENT Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 72, N'SYSREGUSR', N'System Registered User', N'SEE_GROUPCONTENT', N'See GROUPCONTENT Data only self created data from DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 73, N'SYSREGUSR', N'System Registered User', N'EDIT_GROUPCONTENT', N'Edit GROUPCONTENT Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 81, N'SYSREGUSR', N'System Registered User', N'SEE_GROUPCONTENTFEEDBACK', N'See GROUPCONTENTFEEDBACK Data only self created data from DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 82, N'SYSREGUSR', N'System Registered User', N'EDIT_GROUPCONTENTFEEDBACK', N'Edit GROUPCONTENTFEEDBACK Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 83, N'SYSREGUSR', N'System Registered User', N'REMOVE_GROUPCONTENTFEEDBACK', N'Remove GROUPCONTENTFEEDBACK Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 87, N'SYSREGUSR', N'System Registered User', N'CREATE_PROJECTMEMBER', N'Create new PROJECTMEMBER Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 88, N'SYSREGUSR', N'System Registered User', N'READ_PROJECTMEMBER', N'Read PROJECTMEMBER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 91, N'SYSREGUSR', N'System Registered User', N'EDIT_PROJECTMEMBER', N'Edit PROJECTMEMBER Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 92, N'SYSREGUSR', N'System Registered User', N'REMOVE_PROJECTMEMBER', N'Remove PROJECTMEMBER Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 93, N'SYSREGUSR', N'System Registered User', N'CREATE_SOCIETY', N'Create new SOCIETY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 97, N'SYSREGUSR', N'System Registered User', N'EDIT_SOCIETY', N'Edit SOCIETY Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 98, N'SYSREGUSR', N'System Registered User', N'REMOVE_SOCIETY', N'Remove SOCIETY Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 104, N'SYSREGUSR', N'System Registered User', N'SEE_SOCIETY_SERVICECATELOG', N'See SOCIETY_SERVICECATELOG Data only self created data from DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 105, N'SYSREGUSR', N'System Registered User', N'EDIT_SOCIETY_SERVICECATELOG', N'Edit SOCIETY_SERVICECATELOG Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 106, N'SYSREGUSR', N'System Registered User', N'REMOVE_SOCIETY_SERVICECATELOG', N'Remove SOCIETY_SERVICECATELOG Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 114, N'SYSREGUSR', N'System Registered User', N'SEE_SOCIETY_COMMASSETFACILITY', N'See SOCIETY_COMMASSETFACILITY Data only self created data from DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 115, N'SYSREGUSR', N'System Registered User', N'EDIT_SOCIETY_COMMASSETFACILITY', N'Edit SOCIETY_COMMASSETFACILITY Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 116, N'SYSREGUSR', N'System Registered User', N'REMOVE_SOCIETY_COMMASSETFACILITY', N'Remove SOCIETY_COMMASSETFACILITY Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 124, N'SYSREGUSR', N'System Registered User', N'SEE_SOCIETY_FLAT', N'See SOCIETY_FLAT Data only self created data from DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 125, N'SYSREGUSR', N'System Registered User', N'EDIT_SOCIETY_FLAT', N'Edit SOCIETY_FLAT Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 126, N'SYSREGUSR', N'System Registered User', N'REMOVE_SOCIETY_FLAT', N'Remove SOCIETY_FLAT Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 134, N'SYSREGUSR', N'System Registered User', N'SEE_SOCIETY_OWNERREGISTER', N'See SOCIETY_OWNERREGISTER Data only self created data from DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 135, N'SYSREGUSR', N'System Registered User', N'EDIT_SOCIETY_OWNERREGISTER', N'Edit SOCIETY_OWNERREGISTER Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 136, N'SYSREGUSR', N'System Registered User', N'REMOVE_SOCIETY_OWNERREGISTER', N'Remove SOCIETY_OWNERREGISTER Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 144, N'SYSREGUSR', N'System Registered User', N'SEE_SOCIETY_RESIDENTREGISTER', N'See SOCIETY_RESIDENTREGISTER Data only self created data from DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 145, N'SYSREGUSR', N'System Registered User', N'EDIT_SOCIETY_RESIDENTREGISTER', N'Edit SOCIETY_RESIDENTREGISTER Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 146, N'SYSREGUSR', N'System Registered User', N'REMOVE_SOCIETY_RESIDENTREGISTER', N'Remove SOCIETY_RESIDENTREGISTER Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 152, N'SYSREGUSR', N'System Registered User', N'READ_SERVICEMASTER', N'Read SERVICEMASTER Data from DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 155, N'SYSREGUSR', N'System Registered User', N'EDIT_SERVICEMASTER', N'Edit SERVICEMASTER Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 156, N'SYSREGUSR', N'System Registered User', N'REMOVE_SERVICEMASTER', N'Remove SERVICEMASTER Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
-- Data for Organization Super Admin                                                                                                                                                                                                                                                                                                                                   Data for Organization Super Admin                            
-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
--PRINT '.............. [Allocating Activities for Organization Super Admin]'
--GO
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 158, N'ORGSPRADMIN', N'Organization Super Administrator', N'INSERT_MYPROFILE', N'Insert MYPROFILE Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 159, N'ORGSPRADMIN', N'Organization Super Administrator', N'GET_MYPROFILE', N'Get/Read MYPROFILE Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 160, N'ORGSPRADMIN', N'Organization Super Administrator', N'CHANGE_MYPROFILE', N'Change MYPROFILE Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 161, N'ORGSPRADMIN', N'Organization Super Administrator', N'ERASE_MYPROFILE', N'Erase/Purge MYPROFILE Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 28, N'ORGSPRADMIN', N'Organization Super Administrator', N'INSERT_ROLEALLOCATION', N'Insert ROLEALLOCATION Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 29, N'ORGSPRADMIN', N'Organization Super Administrator', N'GET_ROLEALLOCATION', N'Get/Read ROLEALLOCATION Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 30, N'ORGSPRADMIN', N'Organization Super Administrator', N'CHANGE_ROLEALLOCATION', N'Change ROLEALLOCATION Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 31, N'ORGSPRADMIN', N'Organization Super Administrator', N'ERASE_ROLEALLOCATION', N'Erase/Purge ROLEALLOCATION Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 75, N'ORGSPRADMIN', N'Organization Super Administrator', N'INSERT_GROUPCONTENT', N'Insert GROUPCONTENT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 76, N'ORGSPRADMIN', N'Organization Super Administrator', N'GET_GROUPCONTENT', N'Get/Read GROUPCONTENT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 77, N'ORGSPRADMIN', N'Organization Super Administrator', N'CHANGE_GROUPCONTENT', N'Change GROUPCONTENT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 78, N'ORGSPRADMIN', N'Organization Super Administrator', N'ERASE_GROUPCONTENT', N'Erase/Purge GROUPCONTENT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 85, N'ORGSPRADMIN', N'Organization Super Administrator', N'GET_GROUPCONTENTFEEDBACK', N'Get/Read GROUPCONTENTFEEDBACK Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 86, N'ORGSPRADMIN', N'Organization Super Administrator', N'ERASE_GROUPCONTENTFEEDBACK', N'Erase/Purge GROUPCONTENTFEEDBACK Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 100, N'ORGSPRADMIN', N'Organization Super Administrator', N'CHANGE_SOCIETY', N'Change SOCIETY Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 107, N'ORGSPRADMIN', N'Organization Super Administrator', N'INSERT_SOCIETY_SERVICECATELOG', N'Insert SOCIETY_SERVICECATELOG Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 108, N'ORGSPRADMIN', N'Organization Super Administrator', N'GET_SOCIETY_SERVICECATELOG', N'Get/Read SOCIETY_SERVICECATELOG Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 109, N'ORGSPRADMIN', N'Organization Super Administrator', N'CHANGE_SOCIETY_SERVICECATELOG', N'Change SOCIETY_SERVICECATELOG Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 110, N'ORGSPRADMIN', N'Organization Super Administrator', N'ERASE_SOCIETY_SERVICECATELOG', N'Erase/Purge SOCIETY_SERVICECATELOG Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 117, N'ORGSPRADMIN', N'Organization Super Administrator', N'INSERT_SOCIETY_COMMASSETFACILITY', N'Insert SOCIETY_COMMASSETFACILITY Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 118, N'ORGSPRADMIN', N'Organization Super Administrator', N'GET_SOCIETY_COMMASSETFACILITY', N'Get/Read SOCIETY_COMMASSETFACILITY Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 119, N'ORGSPRADMIN', N'Organization Super Administrator', N'CHANGE_SOCIETY_COMMASSETFACILITY', N'Change SOCIETY_COMMASSETFACILITY Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 120, N'ORGSPRADMIN', N'Organization Super Administrator', N'ERASE_SOCIETY_COMMASSETFACILITY', N'Erase/Purge SOCIETY_COMMASSETFACILITY Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 127, N'ORGSPRADMIN', N'Organization Super Administrator', N'INSERT_SOCIETY_FLAT', N'Insert SOCIETY_FLAT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 128, N'ORGSPRADMIN', N'Organization Super Administrator', N'GET_SOCIETY_FLAT', N'Get/Read SOCIETY_FLAT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 129, N'ORGSPRADMIN', N'Organization Super Administrator', N'CHANGE_SOCIETY_FLAT', N'Change SOCIETY_FLAT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 130, N'ORGSPRADMIN', N'Organization Super Administrator', N'ERASE_SOCIETY_FLAT', N'Erase/Purge SOCIETY_FLAT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 137, N'ORGSPRADMIN', N'Organization Super Administrator', N'INSERT_SOCIETY_OWNERREGISTER', N'Insert SOCIETY_OWNERREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 138, N'ORGSPRADMIN', N'Organization Super Administrator', N'GET_SOCIETY_OWNERREGISTER', N'Get/Read SOCIETY_OWNERREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 139, N'ORGSPRADMIN', N'Organization Super Administrator', N'CHANGE_SOCIETY_OWNERREGISTER', N'Change SOCIETY_OWNERREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 140, N'ORGSPRADMIN', N'Organization Super Administrator', N'ERASE_SOCIETY_OWNERREGISTER', N'Erase/Purge SOCIETY_OWNERREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 147, N'ORGSPRADMIN', N'Organization Super Administrator', N'INSERT_SOCIETY_RESIDENTREGISTER', N'Insert SOCIETY_RESIDENTREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 148, N'ORGSPRADMIN', N'Organization Super Administrator', N'GET_SOCIETY_RESIDENTREGISTER', N'Get/Read SOCIETY_RESIDENTREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 149, N'ORGSPRADMIN', N'Organization Super Administrator', N'CHANGE_SOCIETY_RESIDENTREGISTER', N'Change SOCIETY_RESIDENTREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 150, N'ORGSPRADMIN', N'Organization Super Administrator', N'ERASE_SOCIETY_RESIDENTREGISTER', N'Erase/Purge SOCIETY_RESIDENTREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
---- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
---- Data for Organization Admin                                                                                                                                                                                                                                                                                                                                   Data for Organization Admin                            
---- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
--PRINT '.............. [Allocating Activities for Organization Admin]'
--GO
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 158, N'ORGADMIN', N'Organization Administrator', N'INSERT_MYPROFILE', N'Insert MYPROFILE Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 159, N'ORGADMIN', N'Organization Administrator', N'GET_MYPROFILE', N'Get/Read MYPROFILE Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 161, N'ORGADMIN', N'Organization Administrator', N'ERASE_MYPROFILE', N'Erase/Purge MYPROFILE Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 28, N'ORGADMIN', N'Organization Administrator', N'INSERT_ROLEALLOCATION', N'Insert ROLEALLOCATION Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 29, N'ORGADMIN', N'Organization Administrator', N'GET_ROLEALLOCATION', N'Get/Read ROLEALLOCATION Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 30, N'ORGADMIN', N'Organization Administrator', N'CHANGE_ROLEALLOCATION', N'Change ROLEALLOCATION Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 31, N'ORGADMIN', N'Organization Administrator', N'ERASE_ROLEALLOCATION', N'Erase/Purge ROLEALLOCATION Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 75, N'ORGADMIN', N'Organization Administrator', N'INSERT_GROUPCONTENT', N'Insert GROUPCONTENT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 76, N'ORGADMIN', N'Organization Administrator', N'GET_GROUPCONTENT', N'Get/Read GROUPCONTENT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 77, N'ORGADMIN', N'Organization Administrator', N'CHANGE_GROUPCONTENT', N'Change GROUPCONTENT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 78, N'ORGADMIN', N'Organization Administrator', N'ERASE_GROUPCONTENT', N'Erase/Purge GROUPCONTENT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 85, N'ORGADMIN', N'Organization Administrator', N'GET_GROUPCONTENTFEEDBACK', N'Get/Read GROUPCONTENTFEEDBACK Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 86, N'ORGADMIN', N'Organization Administrator', N'ERASE_GROUPCONTENTFEEDBACK', N'Erase/Purge GROUPCONTENTFEEDBACK Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

------INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 93, N'ORGADMIN', N'Organization Administrator', N'CREATE_SOCIETY', N'Create new SOCIETY Data in DB within global scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 100, N'ORGADMIN', N'Organization Administrator', N'CHANGE_SOCIETY', N'Change SOCIETY Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 107, N'ORGADMIN', N'Organization Administrator', N'INSERT_SOCIETY_SERVICECATELOG', N'Insert SOCIETY_SERVICECATELOG Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 108, N'ORGADMIN', N'Organization Administrator', N'GET_SOCIETY_SERVICECATELOG', N'Get/Read SOCIETY_SERVICECATELOG Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 109, N'ORGADMIN', N'Organization Administrator', N'CHANGE_SOCIETY_SERVICECATELOG', N'Change SOCIETY_SERVICECATELOG Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 117, N'ORGADMIN', N'Organization Administrator', N'INSERT_SOCIETY_COMMASSETFACILITY', N'Insert SOCIETY_COMMASSETFACILITY Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 118, N'ORGADMIN', N'Organization Administrator', N'GET_SOCIETY_COMMASSETFACILITY', N'Get/Read SOCIETY_COMMASSETFACILITY Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 119, N'ORGADMIN', N'Organization Administrator', N'CHANGE_SOCIETY_COMMASSETFACILITY', N'Change SOCIETY_COMMASSETFACILITY Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 127, N'ORGADMIN', N'Organization Administrator', N'INSERT_SOCIETY_FLAT', N'Insert SOCIETY_FLAT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 128, N'ORGADMIN', N'Organization Administrator', N'GET_SOCIETY_FLAT', N'Get/Read SOCIETY_FLAT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 129, N'ORGADMIN', N'Organization Administrator', N'CHANGE_SOCIETY_FLAT', N'Change SOCIETY_FLAT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 137, N'ORGADMIN', N'Organization Administrator', N'INSERT_SOCIETY_OWNERREGISTER', N'Insert SOCIETY_OWNERREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 138, N'ORGADMIN', N'Organization Administrator', N'GET_SOCIETY_OWNERREGISTER', N'Get/Read SOCIETY_OWNERREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 139, N'ORGADMIN', N'Organization Administrator', N'CHANGE_SOCIETY_OWNERREGISTER', N'Change SOCIETY_OWNERREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 147, N'ORGADMIN', N'Organization Administrator', N'INSERT_SOCIETY_RESIDENTREGISTER', N'Insert SOCIETY_RESIDENTREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 148, N'ORGADMIN', N'Organization Administrator', N'GET_SOCIETY_RESIDENTREGISTER', N'Get/Read SOCIETY_RESIDENTREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 149, N'ORGADMIN', N'Organization Administrator', N'CHANGE_SOCIETY_RESIDENTREGISTER', N'Change SOCIETY_RESIDENTREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
---- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
---- Data for Organization Operator                                                                                                                                                                                                                                                                                                                                   Data for Organization Operator                            
---- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
--PRINT '.............. [Allocating Activities for Organization Operator]'
--GO
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 75, N'ORGOPRAT', N'Organization Operator', N'INSERT_GROUPCONTENT', N'Insert GROUPCONTENT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 76, N'ORGOPRAT', N'Organization Operator', N'GET_GROUPCONTENT', N'Get/Read GROUPCONTENT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 85, N'ORGOPRAT', N'Organization Operator', N'GET_GROUPCONTENTFEEDBACK', N'Get/Read GROUPCONTENTFEEDBACK Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 107, N'ORGOPRAT', N'Organization Operator', N'INSERT_SOCIETY_SERVICECATELOG', N'Insert SOCIETY_SERVICECATELOG Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 108, N'ORGOPRAT', N'Organization Operator', N'GET_SOCIETY_SERVICECATELOG', N'Get/Read SOCIETY_SERVICECATELOG Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 117, N'ORGOPRAT', N'Organization Operator', N'INSERT_SOCIETY_COMMASSETFACILITY', N'Insert SOCIETY_COMMASSETFACILITY Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 118, N'ORGOPRAT', N'Organization Operator', N'GET_SOCIETY_COMMASSETFACILITY', N'Get/Read SOCIETY_COMMASSETFACILITY Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 127, N'ORGOPRAT', N'Organization Operator', N'INSERT_SOCIETY_FLAT', N'Insert SOCIETY_FLAT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 128, N'ORGOPRAT', N'Organization Operator', N'GET_SOCIETY_FLAT', N'Get/Read SOCIETY_FLAT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 137, N'ORGOPRAT', N'Organization Operator', N'INSERT_SOCIETY_OWNERREGISTER', N'Insert SOCIETY_OWNERREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 138, N'ORGOPRAT', N'Organization Operator', N'GET_SOCIETY_OWNERREGISTER', N'Get/Read SOCIETY_OWNERREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 147, N'ORGOPRAT', N'Organization Operator', N'INSERT_SOCIETY_RESIDENTREGISTER', N'Insert SOCIETY_RESIDENTREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 148, N'ORGOPRAT', N'Organization Operator', N'GET_SOCIETY_RESIDENTREGISTER', N'Get/Read SOCIETY_RESIDENTREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
-- Data for Society Emloyee                                                                                                                                                                                                                                                                                                                                   Data for Society Employee                            
-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
--PRINT '.............. [Allocating Activities for Society Employee]'
--GO
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, 75, N'SCTEMPLOYEE', N'Society Employee', N'INSERT_GROUPCONTENT', N'Insert GROUPCONTENT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, 76, N'SCTEMPLOYEE', N'Society Employee', N'GET_GROUPCONTENT', N'Get/Read GROUPCONTENT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, 84, N'SCTEMPLOYEE', N'Society Employee', N'INSERT_GROUPCONTENTFEEDBACK', N'Insert GROUPCONTENTFEEDBACK Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, 85, N'SCTEMPLOYEE', N'Society Employee', N'GET_GROUPCONTENTFEEDBACK', N'Get/Read GROUPCONTENTFEEDBACK Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, 100, N'SCTEMPLOYEE', N'Society Employee', N'CHANGE_SOCIETY', N'Change SOCIETY Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, 108, N'SCTEMPLOYEE', N'Society Employee', N'GET_SOCIETY_SERVICECATELOG', N'Get/Read SOCIETY_SERVICECATELOG Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, 118, N'SCTEMPLOYEE', N'Society Employee', N'GET_SOCIETY_COMMASSETFACILITY', N'Get/Read SOCIETY_COMMASSETFACILITY Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, 128, N'SCTEMPLOYEE', N'Society Employee', N'GET_SOCIETY_FLAT', N'Get/Read SOCIETY_FLAT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, 138, N'SCTEMPLOYEE', N'Society Employee', N'GET_SOCIETY_OWNERREGISTER', N'Get/Read SOCIETY_OWNERREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, 148, N'SCTEMPLOYEE', N'Society Employee', N'GET_SOCIETY_RESIDENTREGISTER', N'Get/Read SOCIETY_RESIDENTREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
-- Data for Society Flat Owner                                                                                                                                                                                                                                                                                                                                   Data for Society Flat Owner                            
-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
--PRINT '.............. [Allocating Activities for Society Flat Owner]'
--GO
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 75, N'SCTFLATOWNER', N'Society Flat Owner', N'INSERT_GROUPCONTENT', N'Insert GROUPCONTENT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 76, N'SCTFLATOWNER', N'Society Flat Owner', N'GET_GROUPCONTENT', N'Get/Read GROUPCONTENT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 84, N'SCTFLATOWNER', N'Society Flat Owner', N'INSERT_GROUPCONTENTFEEDBACK', N'Insert GROUPCONTENTFEEDBACK Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 85, N'SCTFLATOWNER', N'Society Flat Owner', N'GET_GROUPCONTENTFEEDBACK', N'Get/Read GROUPCONTENTFEEDBACK Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 100, N'SCTFLATOWNER', N'Society Flat Owner', N'CHANGE_SOCIETY', N'Change SOCIETY Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 108, N'SCTFLATOWNER', N'Society Flat Owner', N'GET_SOCIETY_SERVICECATELOG', N'Get/Read SOCIETY_SERVICECATELOG Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 118, N'SCTFLATOWNER', N'Society Flat Owner', N'GET_SOCIETY_COMMASSETFACILITY', N'Get/Read SOCIETY_COMMASSETFACILITY Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 127, N'SCTFLATOWNER', N'Society Flat Owner', N'INSERT_SOCIETY_FLAT', N'Insert SOCIETY_FLAT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 128, N'SCTFLATOWNER', N'Society Flat Owner', N'GET_SOCIETY_FLAT', N'Get/Read SOCIETY_FLAT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 137, N'SCTFLATOWNER', N'Society Flat Owner', N'INSERT_SOCIETY_OWNERREGISTER', N'Insert SOCIETY_OWNERREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 138, N'SCTFLATOWNER', N'Society Flat Owner', N'GET_SOCIETY_OWNERREGISTER', N'Get/Read SOCIETY_OWNERREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 147, N'SCTFLATOWNER', N'Society Flat Owner', N'INSERT_SOCIETY_RESIDENTREGISTER', N'Insert SOCIETY_RESIDENTREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, 148, N'SCTFLATOWNER', N'Society Flat Owner', N'GET_SOCIETY_RESIDENTREGISTER', N'Get/Read SOCIETY_RESIDENTREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
-- Data for Society Resident                                                                                                                                                                                                                                                                                                                                   Data for Society Resident                            
-- =======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
--PRINT '.............. [Allocating Activities for Society Resident]'
--GO
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 75, N'SCTRESIDENT', N'Society Resident', N'INSERT_GROUPCONTENT', N'Insert GROUPCONTENT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 76, N'SCTRESIDENT', N'Society Resident', N'GET_GROUPCONTENT', N'Get/Read GROUPCONTENT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 84, N'SCTRESIDENT', N'Society Resident', N'INSERT_GROUPCONTENTFEEDBACK', N'Insert GROUPCONTENTFEEDBACK Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 85, N'SCTRESIDENT', N'Society Resident', N'GET_GROUPCONTENTFEEDBACK', N'Get/Read GROUPCONTENTFEEDBACK Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 100, N'SCTRESIDENT', N'Society Resident', N'CHANGE_SOCIETY', N'Change SOCIETY Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 108, N'SCTRESIDENT', N'Society Resident', N'GET_SOCIETY_SERVICECATELOG', N'Get/Read SOCIETY_SERVICECATELOG Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 118, N'SCTRESIDENT', N'Society Resident', N'GET_SOCIETY_COMMASSETFACILITY', N'Get/Read SOCIETY_COMMASSETFACILITY Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

----INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 125, N'SCTRESIDENT', N'Society Resident', N'EDIT_SOCIETY_FLAT', N'Edit SOCIETY_FLAT Data only self created data in DB', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 127, N'SCTRESIDENT', N'Society Resident', N'INSERT_SOCIETY_FLAT', N'Insert SOCIETY_FLAT Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 128, N'SCTRESIDENT', N'Society Resident', N'GET_SOCIETY_FLAT', N'Get/Read SOCIETY_FLAT Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 138, N'SCTRESIDENT', N'Society Resident', N'GET_SOCIETY_OWNERREGISTER', N'Get/Read SOCIETY_OWNERREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 147, N'SCTRESIDENT', N'Society Resident', N'INSERT_SOCIETY_RESIDENTREGISTER', N'Insert SOCIETY_RESIDENTREGISTER Data in DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, 148, N'SCTRESIDENT', N'Society Resident', N'GET_SOCIETY_RESIDENTREGISTER', N'Get/Read SOCIETY_RESIDENTREGISTER Data from DB within the organization scope', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
